|
phpmyadmin - Operate MySQL from Web browser
|
| Install phpmyadmin to operate MySQL from Web browser.
Web server is also needed. |
|
| [1] | Install and configure phpmyadmin |
|
[root@www1 ~]# yum -y install phpMyAdmin php-mysql php-mcrypt [root@www1 ~]# vi /etc/phpMyAdmin/config.inc.php # add this line around line 13 # set password $cfg['blowfish_secret'] = 'password'; # line 28: change $cfg['Servers'][$i]['auth_type'] = ' cookie ';[root@www1 ~]# vi /etc/httpd/conf.d/phpMyAdmin.conf # line 8: change Alias /mysql /usr/share/phpMyAdmin# line 13: add IPs you permit Allow from 127.0.0.1 10.0.0.0/24 [root@www1 ~]# /etc/rc.d/init.d/httpd reload Reloading httpd: [ OK ] |
| [2] | Access to 'http://(your hostname)/(alias name you set)/' with web browser, then following screen is shown. Login with a user in MySQL. |
|
| [3] | Just logined. You can operate MySQL on here. |
|